Dataset statistics
| Number of variables | 70 |
|---|---|
| Number of observations | 26648 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 4.3 MiB |
| Average record size in memory | 171.0 B |
Variable types
| BOOL | 55 |
|---|---|
| CAT | 8 |
| NUM | 7 |
flight_code has a high cardinality: 1313 distinct values | High cardinality |
arrival_time has a high cardinality: 906 distinct values | High cardinality |
departure_time_day is highly correlated with departure_time and 1 other fields | High correlation |
departure_time is highly correlated with departure_time_day | High correlation |
departure_date is highly correlated with departure_time_day | High correlation |
number_of_stops has 5301 (19.9%) zeros | Zeros |
departure_day has 6957 (26.1%) zeros | Zeros |
booking_day has 3776 (14.2%) zeros | Zeros |
Reproduction
| Analysis started | 2020-10-07 12:45:31.860970 |
|---|---|
| Analysis finished | 2020-10-07 12:46:31.231637 |
| Duration | 59.37 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
df_index
Real number (ℝ≥0)
| Distinct | 5730 |
|---|---|
| Distinct (%) | 21.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2387.683166 |
|---|---|
| Minimum | 0 |
| Maximum | 5783 |
| Zeros | 7 |
| Zeros (%) | < 0.1% |
| Memory size | 208.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 230 |
| Q1 | 1147 |
| median | 2284.5 |
| Q3 | 3431 |
| 95-th percentile | 5120 |
| Maximum | 5783 |
| Range | 5783 |
| Interquartile range (IQR) | 2284 |
Descriptive statistics
| Standard deviation | 1487.008623 |
|---|---|
| Coefficient of variation (CV) | 0.622783058 |
| Kurtosis | -0.8135551969 |
| Mean | 2387.683166 |
| Median Absolute Deviation (MAD) | 1141.5 |
| Skewness | 0.3230022456 |
| Sum | 63626981 |
| Variance | 2211194.646 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 2023 | 7 | < 0.1% | |
| 3321 | 7 | < 0.1% | |
| 2552 | 7 | < 0.1% | |
| 505 | 7 | < 0.1% | |
| 537 | 7 | < 0.1% | |
| 2616 | 7 | < 0.1% | |
| 2632 | 7 | < 0.1% | |
| 585 | 7 | < 0.1% | |
| 601 | 7 | < 0.1% | |
| 713 | 7 | < 0.1% | |
| Other values (5720) | 26578 | 99.7% |
| Value | Count | Frequency (%) | |
| 0 | 7 | < 0.1% | |
| 1 | 7 | < 0.1% | |
| 2 | 7 | < 0.1% | |
| 3 | 7 | < 0.1% | |
| 4 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 5783 | 1 | < 0.1% | |
| 5782 | 1 | < 0.1% | |
| 5781 | 1 | < 0.1% | |
| 5780 | 1 | < 0.1% | |
| 5779 | 1 | < 0.1% |
Air India
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22751 | 85.4% | |
| 1 | 3897 | 14.6% |
AirAsia
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1672 |
| Value | Count | Frequency (%) | |
| 0 | 24976 | 93.7% | |
| 1 | 1672 | 6.3% |
Go Air
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1351 |
| Value | Count | Frequency (%) | |
| 0 | 25297 | 94.9% | |
| 1 | 1351 | 5.1% |
IndiGo
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 16454 | 61.7% | |
| 1 | 10194 | 38.3% |
Spicejet
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 20817 | 78.1% | |
| 1 | 5831 | 21.9% |
Vistara
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22945 | 86.1% | |
| 1 | 3703 | 13.9% |
airline
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| IndiGo | |
|---|---|
| Spicejet | |
| Air India | |
| Vistara | |
| AirAsia |
| Value | Count | Frequency (%) | |
| IndiGo | 10194 | 38.3% | |
| Spicejet | 5831 | 21.9% | |
| Air India | 3897 | 14.6% | |
| Vistara | 3703 | 13.9% | |
| AirAsia | 1672 | 6.3% | |
| Go Air | 1351 | 5.1% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.078054638 |
| Min length | 6 |
| Distinct | 1313 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| SG-789 | 168 |
|---|---|
| UK-944 | UK-813 | 56 |
| SG-8152 | SG-8705 | 56 |
| SG-8152 | SG-3724 | 56 |
| 6E-128 | 56 |
| Other values (1308) |
| Value | Count | Frequency (%) | |
| SG-789 | 168 | 0.6% | |
| UK-944 | UK-813 | 56 | 0.2% | |
| SG-8152 | SG-8705 | 56 | 0.2% | |
| SG-8152 | SG-3724 | 56 | 0.2% | |
| 6E-128 | 56 | 0.2% | |
| 6E-6328 | 6E-167 | 56 | 0.2% | |
| 6E-427 | 6E-2405 | 56 | 0.2% | |
| 6E-6834 | 6E-322 | 56 | 0.2% | |
| AI-866 | 56 | 0.2% | |
| 6E-426 | 6E-582 | 56 | 0.2% | |
| Other values (1303) | 25976 | 97.5% |
Unique
| Unique | 128 ? |
|---|---|
| Unique (%) | 0.5% |
Length
| Max length | 37 |
|---|---|
| Median length | 15 |
| Mean length | 14.89969228 |
| Min length | 6 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| morning | |
|---|---|
| afternoon | |
| evening | |
| night | 418 |
| Value | Count | Frequency (%) | |
| morning | 14568 | 54.7% | |
| afternoon | 7556 | 28.4% | |
| evening | 4106 | 15.4% | |
| night | 418 | 1.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.535725008 |
| Min length | 5 |
flight_duration
Real number (ℝ≥0)
| Distinct | 274 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 494.9568448 |
|---|---|
| Minimum | 0 |
| Maximum | 1435 |
| Zeros | 40 |
| Zeros (%) | 0.2% |
| Memory size | 208.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 115 |
| Q1 | 205 |
| median | 425 |
| Q3 | 715 |
| 95-th percentile | 1135 |
| Maximum | 1435 |
| Range | 1435 |
| Interquartile range (IQR) | 510 |
Descriptive statistics
| Standard deviation | 324.9110891 |
|---|---|
| Coefficient of variation (CV) | 0.6564432688 |
| Kurtosis | -0.08552123497 |
| Mean | 494.9568448 |
| Median Absolute Deviation (MAD) | 245 |
| Skewness | 0.7614929635 |
| Sum | 13189610 |
| Variance | 105567.2158 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 125 | 1061 | 4.0% | |
| 130 | 962 | 3.6% | |
| 135 | 865 | 3.2% | |
| 420 | 464 | 1.7% | |
| 165 | 464 | 1.7% | |
| 170 | 434 | 1.6% | |
| 330 | 428 | 1.6% | |
| 425 | 331 | 1.2% | |
| 410 | 311 | 1.2% | |
| 635 | 297 | 1.1% | |
| Other values (264) | 21031 | 78.9% |
| Value | Count | Frequency (%) | |
| 0 | 40 | 0.2% | |
| 5 | 24 | 0.1% | |
| 10 | 53 | 0.2% | |
| 15 | 6 | < 0.1% | |
| 20 | 26 | 0.1% |
| Value | Count | Frequency (%) | |
| 1435 | 14 | 0.1% | |
| 1430 | 55 | 0.2% | |
| 1425 | 9 | < 0.1% | |
| 1405 | 26 | 0.1% | |
| 1400 | 62 | 0.2% |
| Distinct | 906 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| 20:30 | 509 |
|---|---|
| 22:35 | 483 |
| 20:15 | 480 |
| 20:40 | 420 |
| 19:15 | 382 |
| Other values (901) |
| Value | Count | Frequency (%) | |
| 20:30 | 509 | 1.9% | |
| 22:35 | 483 | 1.8% | |
| 20:15 | 480 | 1.8% | |
| 20:40 | 420 | 1.6% | |
| 19:15 | 382 | 1.4% | |
| 20:50 | 339 | 1.3% | |
| 17:30 | 319 | 1.2% | |
| 22:45 | 290 | 1.1% | |
| 20:45 | 274 | 1.0% | |
| 18:20 | 273 | 1.0% | |
| Other values (896) | 22879 | 85.9% |
Unique
| Unique | 57 ? |
|---|---|
| Unique (%) | 0.2% |
Length
| Max length | 41 |
|---|---|
| Median length | 5 |
| Mean length | 13.00682978 |
| Min length | 5 |
flight_cost
Real number (ℝ≥0)
| Distinct | 1060 |
|---|---|
| Distinct (%) | 4.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5151.78974 |
|---|---|
| Minimum | 2540 |
| Maximum | 20674 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 208.2 KiB |
Quantile statistics
| Minimum | 2540 |
|---|---|
| 5-th percentile | 3323 |
| Q1 | 3797 |
| median | 4680 |
| Q3 | 5910 |
| 95-th percentile | 8731 |
| Maximum | 20674 |
| Range | 18134 |
| Interquartile range (IQR) | 2113 |
Descriptive statistics
| Standard deviation | 1869.544629 |
|---|---|
| Coefficient of variation (CV) | 0.3628922613 |
| Kurtosis | 5.198739453 |
| Mean | 5151.78974 |
| Median Absolute Deviation (MAD) | 883 |
| Skewness | 1.906065332 |
| Sum | 137284893 |
| Variance | 3495197.118 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 3797 | 1770 | 6.6% | |
| 3746 | 1433 | 5.4% | |
| 3955 | 1232 | 4.6% | |
| 3481 | 1119 | 4.2% | |
| 3271 | 890 | 3.3% | |
| 5132 | 872 | 3.3% | |
| 4006 | 715 | 2.7% | |
| 4712 | 635 | 2.4% | |
| 3956 | 560 | 2.1% | |
| 4922 | 424 | 1.6% | |
| Other values (1050) | 16998 | 63.8% |
| Value | Count | Frequency (%) | |
| 2540 | 3 | < 0.1% | |
| 2955 | 53 | 0.2% | |
| 2956 | 64 | 0.2% | |
| 2957 | 202 | 0.8% | |
| 3061 | 7 | < 0.1% |
| Value | Count | Frequency (%) | |
| 20674 | 4 | < 0.1% | |
| 20666 | 1 | < 0.1% | |
| 18866 | 1 | < 0.1% | |
| 18486 | 1 | < 0.1% | |
| 18445 | 1 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9828129691 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 5301 |
| Zeros (%) | 19.9% |
| Memory size | 208.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6768069427 |
|---|---|
| Coefficient of variation (CV) | 0.6886426654 |
| Kurtosis | 1.941358959 |
| Mean | 0.9828129691 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.8233686836 |
| Sum | 26190 |
| Variance | 0.4580676376 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 17470 | 65.6% | |
| 0 | 5301 | 19.9% | |
| 2 | 2979 | 11.2% | |
| 3 | 831 | 3.1% | |
| 4 | 66 | 0.2% | |
| 5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 5301 | 19.9% | |
| 1 | 17470 | 65.6% | |
| 2 | 2979 | 11.2% | |
| 3 | 831 | 3.1% | |
| 4 | 66 | 0.2% |
| Value | Count | Frequency (%) | |
| 5 | 1 | < 0.1% | |
| 4 | 66 | 0.2% | |
| 3 | 831 | 3.1% | |
| 2 | 2979 | 11.2% | |
| 1 | 17470 | 65.6% |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| 2020-10-12 | |
|---|---|
| 2020-10-11 | |
| 2020-10-07 | |
| 2020-10-09 | |
| 2020-10-10 | |
| Other values (3) |
| Value | Count | Frequency (%) | |
| 2020-10-12 | 3718 | 14.0% | |
| 2020-10-11 | 3553 | 13.3% | |
| 2020-10-07 | 3454 | 13.0% | |
| 2020-10-09 | 3445 | 12.9% | |
| 2020-10-10 | 3280 | 12.3% | |
| 2020-10-05 | 3239 | 12.2% | |
| 2020-10-08 | 3133 | 11.8% | |
| 2020-10-06 | 2826 | 10.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.650517863 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 6957 |
| Zeros (%) | 26.1% |
| Memory size | 104.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.145478968 |
|---|---|
| Coefficient of variation (CV) | 0.8094565212 |
| Kurtosis | -1.3641934 |
| Mean | 2.650517863 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.1575318788 |
| Sum | 70631 |
| Variance | 4.603080004 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 6957 | 26.1% | |
| 6 | 3553 | 13.3% | |
| 2 | 3454 | 13.0% | |
| 4 | 3445 | 12.9% | |
| 5 | 3280 | 12.3% | |
| 3 | 3133 | 11.8% | |
| 1 | 2826 | 10.6% |
| Value | Count | Frequency (%) | |
| 0 | 6957 | 26.1% | |
| 1 | 2826 | 10.6% | |
| 2 | 3454 | 13.0% | |
| 3 | 3133 | 11.8% | |
| 4 | 3445 | 12.9% |
| Value | Count | Frequency (%) | |
| 6 | 3553 | 13.3% | |
| 5 | 3280 | 12.3% | |
| 4 | 3445 | 12.9% | |
| 3 | 3133 | 11.8% | |
| 2 | 3454 | 13.0% |
booking_date
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| 2020-10-04 | |
|---|---|
| 2020-10-02 | |
| 2020-10-03 | |
| 2020-09-28 | |
| 2020-10-01 | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| 2020-10-04 | 4054 | 15.2% | |
| 2020-10-02 | 4044 | 15.2% | |
| 2020-10-03 | 4037 | 15.1% | |
| 2020-09-28 | 3776 | 14.2% | |
| 2020-10-01 | 3705 | 13.9% | |
| 2020-09-29 | 3518 | 13.2% | |
| 2020-09-30 | 3514 | 13.2% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.090138097 |
|---|---|
| Minimum | 0 |
| Maximum | 6 |
| Zeros | 3776 |
| Zeros (%) | 14.2% |
| Memory size | 208.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 6 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.013497147 |
|---|---|
| Coefficient of variation (CV) | 0.6515880793 |
| Kurtosis | -1.256603876 |
| Mean | 3.090138097 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.07836505984 |
| Sum | 82346 |
| Variance | 4.054170762 |
| Monotocity | Increasing |
| Value | Count | Frequency (%) | |
| 6 | 4054 | 15.2% | |
| 4 | 4044 | 15.2% | |
| 5 | 4037 | 15.1% | |
| 0 | 3776 | 14.2% | |
| 3 | 3705 | 13.9% | |
| 1 | 3518 | 13.2% | |
| 2 | 3514 | 13.2% |
| Value | Count | Frequency (%) | |
| 0 | 3776 | 14.2% | |
| 1 | 3518 | 13.2% | |
| 2 | 3514 | 13.2% | |
| 3 | 3705 | 13.9% | |
| 4 | 4044 | 15.2% |
| Value | Count | Frequency (%) | |
| 6 | 4054 | 15.2% | |
| 5 | 4037 | 15.1% | |
| 4 | 4044 | 15.2% | |
| 3 | 3705 | 13.9% | |
| 2 | 3514 | 13.2% |
days_to_depart
Real number (ℝ≥0)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.537038427 |
|---|---|
| Minimum | 1 |
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 208.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 8 |
| Q3 | 10 |
| 95-th percentile | 13 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.030074316 |
|---|---|
| Coefficient of variation (CV) | 0.402024528 |
| Kurtosis | -0.6183467638 |
| Mean | 7.537038427 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.0108659168 |
| Sum | 200847 |
| Variance | 9.181350361 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 8 | 3437 | 12.9% | |
| 7 | 3350 | 12.6% | |
| 9 | 2899 | 10.9% | |
| 6 | 2714 | 10.2% | |
| 10 | 2460 | 9.2% | |
| 5 | 2376 | 8.9% | |
| 11 | 1888 | 7.1% | |
| 4 | 1860 | 7.0% | |
| 3 | 1446 | 5.4% | |
| 12 | 1406 | 5.3% | |
| Other values (4) | 2812 | 10.6% |
| Value | Count | Frequency (%) | |
| 1 | 454 | 1.7% | |
| 2 | 907 | 3.4% | |
| 3 | 1446 | 5.4% | |
| 4 | 1860 | 7.0% | |
| 5 | 2376 | 8.9% |
| Value | Count | Frequency (%) | |
| 14 | 497 | 1.9% | |
| 13 | 954 | 3.6% | |
| 12 | 1406 | 5.3% | |
| 11 | 1888 | 7.1% | |
| 10 | 2460 | 9.2% |
flight_path
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| Bengaluru-New Delhi | |
|---|---|
| Mumbai-New Delhi | |
| New Delhi-Mumbai | |
| Mumbai-Bengaluru | |
| New Delhi-Kolkata | |
| Other values (2) |
| Value | Count | Frequency (%) | |
| Bengaluru-New Delhi | 5780 | 21.7% | |
| Mumbai-New Delhi | 5184 | 19.5% | |
| New Delhi-Mumbai | 4535 | 17.0% | |
| Mumbai-Bengaluru | 4360 | 16.4% | |
| New Delhi-Kolkata | 4092 | 15.4% | |
| New Delhi-Goa | 2000 | 7.5% | |
| Mumbai-Goa | 697 | 2.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 19 |
|---|---|
| Median length | 16 |
| Mean length | 16.42217052 |
| Min length | 10 |
Bengaluru-New Delhi
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 20868 | 78.3% | |
| 1 | 5780 | 21.7% |
Mumbai-Bengaluru
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22288 | 83.6% | |
| 1 | 4360 | 16.4% |
Mumbai-Goa
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 697 |
| Value | Count | Frequency (%) | |
| 0 | 25951 | 97.4% | |
| 1 | 697 | 2.6% |
Mumbai-New Delhi
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 21464 | 80.5% | |
| 1 | 5184 | 19.5% |
New Delhi-Goa
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 2000 |
| Value | Count | Frequency (%) | |
| 0 | 24648 | 92.5% | |
| 1 | 2000 | 7.5% |
New Delhi-Kolkata
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22556 | 84.6% | |
| 1 | 4092 | 15.4% |
New Delhi-Mumbai
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22113 | 83.0% | |
| 1 | 4535 | 17.0% |
bd__0
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22872 | 85.8% | |
| 1 | 3776 | 14.2% |
bd__1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23130 | 86.8% | |
| 1 | 3518 | 13.2% |
bd__2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23134 | 86.8% | |
| 1 | 3514 | 13.2% |
bd__3
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22943 | 86.1% | |
| 1 | 3705 | 13.9% |
bd__4
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22604 | 84.8% | |
| 1 | 4044 | 15.2% |
bd__5
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22611 | 84.9% | |
| 1 | 4037 | 15.1% |
bd__6
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22594 | 84.8% | |
| 1 | 4054 | 15.2% |
dd__0
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 19691 | 73.9% | |
| 1 | 6957 | 26.1% |
dd__1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23822 | 89.4% | |
| 1 | 2826 | 10.6% |
dd__2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23194 | 87.0% | |
| 1 | 3454 | 13.0% |
dd__3
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23515 | 88.2% | |
| 1 | 3133 | 11.8% |
dd__4
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23203 | 87.1% | |
| 1 | 3445 | 12.9% |
dd__5
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23368 | 87.7% | |
| 1 | 3280 | 12.3% |
dd__6
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 23095 | 86.7% | |
| 1 | 3553 | 13.3% |
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 208.2 KiB |
| morning-0 | |
|---|---|
| morning-6 | |
| afternoon-0 | |
| morning-4 | |
| morning-5 | |
| Other values (23) |
| Value | Count | Frequency (%) | |
| morning-0 | 3903 | 14.6% | |
| morning-6 | 1935 | 7.3% | |
| afternoon-0 | 1934 | 7.3% | |
| morning-4 | 1884 | 7.1% | |
| morning-5 | 1828 | 6.9% | |
| morning-2 | 1799 | 6.8% | |
| morning-3 | 1686 | 6.3% | |
| morning-1 | 1533 | 5.8% | |
| afternoon-2 | 1069 | 4.0% | |
| evening-0 | 1009 | 3.8% | |
| Other values (18) | 8068 | 30.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.535725008 |
| Min length | 7 |
afternoon-0
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1934 |
| Value | Count | Frequency (%) | |
| 0 | 24714 | 92.7% | |
| 1 | 1934 | 7.3% |
afternoon-1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 769 |
| Value | Count | Frequency (%) | |
| 0 | 25879 | 97.1% | |
| 1 | 769 | 2.9% |
afternoon-2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1069 |
| Value | Count | Frequency (%) | |
| 0 | 25579 | 96.0% | |
| 1 | 1069 | 4.0% |
afternoon-3
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 896 |
| Value | Count | Frequency (%) | |
| 0 | 25752 | 96.6% | |
| 1 | 896 | 3.4% |
afternoon-4
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 962 |
| Value | Count | Frequency (%) | |
| 0 | 25686 | 96.4% | |
| 1 | 962 | 3.6% |
afternoon-5
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 919 |
| Value | Count | Frequency (%) | |
| 0 | 25729 | 96.6% | |
| 1 | 919 | 3.4% |
afternoon-6
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1007 |
| Value | Count | Frequency (%) | |
| 0 | 25641 | 96.2% | |
| 1 | 1007 | 3.8% |
evening-0
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1009 |
| Value | Count | Frequency (%) | |
| 0 | 25639 | 96.2% | |
| 1 | 1009 | 3.8% |
evening-1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 471 |
| Value | Count | Frequency (%) | |
| 0 | 26177 | 98.2% | |
| 1 | 471 | 1.8% |
evening-2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 529 |
| Value | Count | Frequency (%) | |
| 0 | 26119 | 98.0% | |
| 1 | 529 | 2.0% |
evening-3
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 505 |
| Value | Count | Frequency (%) | |
| 0 | 26143 | 98.1% | |
| 1 | 505 | 1.9% |
evening-4
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 550 |
| Value | Count | Frequency (%) | |
| 0 | 26098 | 97.9% | |
| 1 | 550 | 2.1% |
evening-5
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 483 |
| Value | Count | Frequency (%) | |
| 0 | 26165 | 98.2% | |
| 1 | 483 | 1.8% |
evening-6
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 559 |
| Value | Count | Frequency (%) | |
| 0 | 26089 | 97.9% | |
| 1 | 559 | 2.1% |
morning-0
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 |
| Value | Count | Frequency (%) | |
| 0 | 22745 | 85.4% | |
| 1 | 3903 | 14.6% |
morning-1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1533 |
| Value | Count | Frequency (%) | |
| 0 | 25115 | 94.2% | |
| 1 | 1533 | 5.8% |
morning-2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1799 |
| Value | Count | Frequency (%) | |
| 0 | 24849 | 93.2% | |
| 1 | 1799 | 6.8% |
morning-3
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1686 |
| Value | Count | Frequency (%) | |
| 0 | 24962 | 93.7% | |
| 1 | 1686 | 6.3% |
morning-4
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1884 |
| Value | Count | Frequency (%) | |
| 0 | 24764 | 92.9% | |
| 1 | 1884 | 7.1% |
morning-5
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1828 |
| Value | Count | Frequency (%) | |
| 0 | 24820 | 93.1% | |
| 1 | 1828 | 6.9% |
morning-6
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 1935 |
| Value | Count | Frequency (%) | |
| 0 | 24713 | 92.7% | |
| 1 | 1935 | 7.3% |
night-0
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 111 |
| Value | Count | Frequency (%) | |
| 0 | 26537 | 99.6% | |
| 1 | 111 | 0.4% |
night-1
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 53 |
| Value | Count | Frequency (%) | |
| 0 | 26595 | 99.8% | |
| 1 | 53 | 0.2% |
night-2
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 57 |
| Value | Count | Frequency (%) | |
| 0 | 26591 | 99.8% | |
| 1 | 57 | 0.2% |
night-3
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 46 |
| Value | Count | Frequency (%) | |
| 0 | 26602 | 99.8% | |
| 1 | 46 | 0.2% |
night-4
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 49 |
| Value | Count | Frequency (%) | |
| 0 | 26599 | 99.8% | |
| 1 | 49 | 0.2% |
night-5
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 50 |
| Value | Count | Frequency (%) | |
| 0 | 26598 | 99.8% | |
| 1 | 50 | 0.2% |
night-6
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.0 KiB |
| 0 | |
|---|---|
| 1 | 52 |
| Value | Count | Frequency (%) | |
| 0 | 26596 | 99.8% | |
| 1 | 52 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | Air India | AirAsia | Go Air | IndiGo | Spicejet | Vistara | airline | flight_code | departure_time | flight_duration | arrival_time | flight_cost | number_of_stops | departure_date | departure_day | booking_date | booking_day | days_to_depart | flight_path | Bengaluru-New Delhi | Mumbai-Bengaluru | Mumbai-Goa | Mumbai-New Delhi | New Delhi-Goa | New Delhi-Kolkata | New Delhi-Mumbai | bd__0 | bd__1 | bd__2 | bd__3 | bd__4 | bd__5 | bd__6 | dd__0 | dd__1 | dd__2 | dd__3 | dd__4 | dd__5 | dd__6 | departure_time_day | afternoon-0 | afternoon-1 | afternoon-2 | afternoon-3 | afternoon-4 | afternoon-5 | afternoon-6 | evening-0 | evening-1 | evening-2 | evening-3 | evening-4 | evening-5 | evening-6 | morning-0 | morning-1 | morning-2 | morning-3 | morning-4 | morning-5 | morning-6 | night-0 | night-1 | night-2 | night-3 | night-4 | night-5 | night-6 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | AirAsia | I5-302 | I5-741 | morning | 540.0 | 14:50 | 3500 | 1 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | AirAsia | I5-317 | I5-979 | morning | 660.0 | 21:45 | 3500 | 1 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | AirAsia | I5-984 | I5-741 | night | 860.0 | 13:45+1 DAYArrival : New Delhi06 Oct 2020 | 3868 | 1 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | night-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | 3 | 0 | 0 | 1 | 0 | 0 | 0 | Go Air | G8-306 | G8-175 | evening | 760.0 | 10:30+1 DAYArrival : New Delhi06 Oct 2020 | 3500 | 1 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | evening-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | 4 | 0 | 0 | 1 | 0 | 0 | 0 | Go Air | G8-322 | evening | 125.0 | 23:40 | 3500 | 0 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | evening-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5 | 5 | 0 | 0 | 1 | 0 | 0 | 0 | Go Air | G8-327 | morning | 140.0 | 08:05 | 3868 | 0 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 6 | 6 | 0 | 0 | 0 | 0 | 0 | 1 | Vistara | UK-960 | morning | 125.0 | 13:20 | 3500 | 0 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 7 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | Vistara | UK-944 | afternoon | 125.0 | 15:40 | 3500 | 0 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | afternoon-0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 8 | 8 | 0 | 0 | 0 | 0 | 1 | 0 | Spicejet | SG-790 | afternoon | 125.0 | 17:20 | 3868 | 0 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | afternoon-0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 9 | 9 | 0 | 0 | 0 | 0 | 0 | 1 | Vistara | UK-940 | evening | 125.0 | 21:45 | 3501 | 0 | 2020-10-05 | 0 | 2020-09-28 | 0 | 7 | Mumbai-New Delhi | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | evening-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Last rows
| df_index | Air India | AirAsia | Go Air | IndiGo | Spicejet | Vistara | airline | flight_code | departure_time | flight_duration | arrival_time | flight_cost | number_of_stops | departure_date | departure_day | booking_date | booking_day | days_to_depart | flight_path | Bengaluru-New Delhi | Mumbai-Bengaluru | Mumbai-Goa | Mumbai-New Delhi | New Delhi-Goa | New Delhi-Kolkata | New Delhi-Mumbai | bd__0 | bd__1 | bd__2 | bd__3 | bd__4 | bd__5 | bd__6 | dd__0 | dd__1 | dd__2 | dd__3 | dd__4 | dd__5 | dd__6 | departure_time_day | afternoon-0 | afternoon-1 | afternoon-2 | afternoon-3 | afternoon-4 | afternoon-5 | afternoon-6 | evening-0 | evening-1 | evening-2 | evening-3 | evening-4 | evening-5 | evening-6 | morning-0 | morning-1 | morning-2 | morning-3 | morning-4 | morning-5 | morning-6 | night-0 | night-1 | night-2 | night-3 | night-4 | night-5 | night-6 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26638 | 5773 | 1 | 0 | 0 | 0 | 0 | 0 | Air India | AI-544 | AI-525 | afternoon | 940.0 | 07:55+1 DAYArrival : Kolkata13 Oct 2020 | 9435 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | afternoon-0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26639 | 5774 | 0 | 0 | 0 | 0 | 1 | 0 | Spicejet | SG-8169 | SG-241 | evening | 760.0 | 08:30+1 DAYArrival : Kolkata13 Oct 2020 | 11687 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | evening-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26640 | 5775 | 0 | 0 | 0 | 0 | 1 | 0 | Spicejet | SG-8169 | SG-487 | evening | 160.0 | 22:30+1 DAYArrival : Kolkata13 Oct 2020 | 4740 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | evening-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26641 | 5777 | 0 | 0 | 0 | 1 | 0 | 0 | IndiGo | 6E-2192 | 6E-6292 | afternoon | 370.0 | 20:15 | 9435 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | afternoon-0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26642 | 5778 | 0 | 0 | 0 | 1 | 0 | 0 | IndiGo | 6E-277 | 6E-6292 | morning | 630.0 | 20:15 | 11687 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26643 | 5779 | 0 | 0 | 0 | 1 | 0 | 0 | IndiGo | 6E-251 | 6E-349 | morning | 410.0 | 11:50 | 4740 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26644 | 5780 | 1 | 0 | 0 | 0 | 0 | 0 | Air India | AI-504 | AI-776 | evening | 780.0 | 10:40+1 DAYArrival : Kolkata13 Oct 2020 | 4740 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | evening-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26645 | 5781 | 0 | 0 | 0 | 0 | 0 | 1 | Vistara | UK-995 | UK-775 | morning | 450.0 | 16:55 | 8912 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26646 | 5782 | 0 | 0 | 0 | 0 | 0 | 1 | Vistara | UK-943 | UK-775 | morning | 550.0 | 16:55 | 11176 | 1 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | morning-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 26647 | 5783 | 1 | 0 | 0 | 0 | 0 | 0 | Air India | AI-851 | AI-571 | AI-525 | night | 190.0 | 07:55+1 DAYArrival : Kolkata13 Oct 2020 | 4740 | 3 | 2020-10-12 | 0 | 2020-10-04 | 6 | 8 | New Delhi-Kolkata | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | night-0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |